Blog

Back

Hello SQL

Posted at 13, Jan, 2025

When I was in high school my math teacher took a standard linear equation and asked the class what would hapeen if we squared the equation. So he proceeded to do the math which took a large part of the class as he wanted us to understand every step of the process. At the end he asked us to graph the result in our graphing calculator. We were familar with Linear equations that graphed as “straight lines” and its real world applicaitons ; however, this was the first time we saw a “curved line” in a graph. It was at that point where he introduced an entirely new concept of the quadratic equation. He went on about how these lines could be used in functional ways and thus began the new teaching unit.

This is the type of learning that gets internalized—the kind you truly digest, understanding its core concepts and knowing ‘why’ before ‘how.’ In an age where we often memorize just enough for a test (read: certification chruning ) or to add something to a resume, we miss out on the actual education and value of the subject. This is how I approach learning. education > schooling.

(Side note : I might have to play around with apple shortcuts to auto populate the frontmatter when generating a new note as to make the uploading process more efficient)

Shall we begin

SQL

Was introduced in 1970 (woah! Still in demand after so many years) by a couple of IBM scientists. 1 Was initially called Structured English Query Language ( SEQUEL ), later known as SQL .1

I found a great youtube video on SQL I will be referencing for my learning journey.

The Basics

Databases (DB) store information. The software that handles editing information in those DBs is called DBMS (Database Management Systems).

There are 2 types of databases , Relational and Non relational. Relational Dbs have rows columns and a primary key (idk what that is …yet) Non relational Dbs dont have that and have other random shit in then.

Relation DBs use SQL as the standard langauge to create, read, update and delete . Non Relation DBs use some other shit to manage the information - not important .

There are different variations of SQL depending on the management system (sort of like different dialects in a language)

  1. https://www.ibm.com/think/topics/structured-query-language 2